When ranking groups manually, you must enter criteria for each ranking group.
Note: When defining your manual rankings, you should use higher numbers for more desirable rankings and lower numbers for less desirable rankings to conform to industry standards for RFM rankings.
Example of ranking values manually for RFM analysis
Recency
The criteria for ranking Recency is based on the last time the individual had contact with the organization. The date used is based on the Transaction Date specified in the Transaction Query. The following table illustrates how Recency is ranked:
Group Name |
Value |
Description |
|||
---|---|---|---|---|---|
A |
15 |
> 10 days and < = 15 days |
|||
B |
10 |
> 5 days and < = 10 days |
|||
C |
5 |
< = 5 days |
Frequency
The criteria for ranking Frequency is based on the number of times the individual had contact with the organization. The number of times is calculated by the number of records for an individual in the Transaction Query. The following table illustrates how Frequency is ranked:
Group Name |
Value |
Description |
|||
---|---|---|---|---|---|
M |
0 |
< 20 times and > = 0 times |
|||
N |
20 |
< 30 times and > = 20 times |
|||
O |
30 |
< 50 times and > = 30 times |
|||
P |
50 |
> = 50 times |
Monetary
The criteria for ranking Monetary is based on the amount of money the individual has spent with the organization. The amount is based on the total amount from the Transaction Query. The following table illustrates how Monetary is ranked:
Group Name |
Value |
Description |
|||
---|---|---|---|---|---|
T |
50 |
< 100 and > = 50 |
|||
S |
100 |
< 200 and > = 100 |
|||
R |
200 |
< 500 and > = 200 |
|||
Q |
500 |
> = 500 |
To create an analysis definition
10.6 Production Release. Updated 3/8/2006 1:46:42 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.